Reporte de Datos Originales

Dataset statistics

Number of variables	43
Number of observations	198910
Missing cells	2246072
Missing cells (%)	26.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	350.2 MiB
Average record size in memory	1.8 KiB

Variable types

Text	10
Numeric	13
Categorical	8
DateTime	7
Boolean	4
Unsupported	1

Alerts

`Structural Notification` has constant value "True"	Constant
`Voluntary Soft-Story Retrofit` has constant value "True"	Constant
`Fire Only Permit` has constant value "True"	Constant
`Site Permit` has constant value "True"	Constant
`Estimated Cost` is highly overall correlated with `Revised Cost`	High correlation
`Existing Construction Type` is highly overall correlated with `Number of Existing Stories` and 2 other fields	High correlation
`Existing Construction Type Description` is highly overall correlated with `Proposed Construction Type` and 1 other fields	High correlation
`Existing Units` is highly overall correlated with `Proposed Units`	High correlation
`Neighborhoods - Analysis Boundaries` is highly overall correlated with `Zipcode`	High correlation
`Number of Existing Stories` is highly overall correlated with `Existing Construction Type` and 1 other fields	High correlation
`Number of Proposed Stories` is highly overall correlated with `Existing Construction Type` and 1 other fields	High correlation
`Permit Type` is highly overall correlated with `Permit Type Definition`	High correlation
`Permit Type Definition` is highly overall correlated with `Permit Type`	High correlation
`Plansets` is highly overall correlated with `Street Number Suffix`	High correlation
`Proposed Construction Type` is highly overall correlated with `Existing Construction Type Description` and 1 other fields	High correlation
`Proposed Construction Type Description` is highly overall correlated with `Existing Construction Type Description` and 1 other fields	High correlation
`Proposed Units` is highly overall correlated with `Existing Units`	High correlation
`Revised Cost` is highly overall correlated with `Estimated Cost`	High correlation
`Street Number Suffix` is highly overall correlated with `Existing Construction Type` and 1 other fields	High correlation
`Zipcode` is highly overall correlated with `Neighborhoods - Analysis Boundaries`	High correlation
`Permit Type Definition` is highly imbalanced (83.5%)	Imbalance
`Street Number Suffix` is highly imbalanced (59.2%)	Imbalance
`Street Suffix` is highly imbalanced (69.9%)	Imbalance
`Current Status` is highly imbalanced (60.4%)	Imbalance
`Existing Construction Type Description` is highly imbalanced (60.4%)	Imbalance
`Street Number Suffix` has 196694 (98.9%) missing values	Missing
`Street Suffix` has 2768 (1.4%) missing values	Missing
`Unit` has 169430 (85.2%) missing values	Missing
`Unit Suffix` has 196949 (99.0%) missing values	Missing
`Issued Date` has 14942 (7.5%) missing values	Missing
`Completed Date` has 101715 (51.1%) missing values	Missing
`First Construction Document Date` has 14948 (7.5%) missing values	Missing
`Structural Notification` has 191988 (96.5%) missing values	Missing
`Number of Existing Stories` has 42788 (21.5%) missing values	Missing
`Number of Proposed Stories` has 42871 (21.6%) missing values	Missing
`Voluntary Soft-Story Retrofit` has 198875 (> 99.9%) missing values	Missing
`Fire Only Permit` has 180082 (90.5%) missing values	Missing
`Permit Expiration Date` has 51884 (26.1%) missing values	Missing
`Estimated Cost` has 38068 (19.1%) missing values	Missing
`Revised Cost` has 6066 (3.0%) missing values	Missing
`Existing Use` has 41117 (20.7%) missing values	Missing
`Existing Units` has 51543 (25.9%) missing values	Missing
`Proposed Use` has 42441 (21.3%) missing values	Missing
`Proposed Units` has 50915 (25.6%) missing values	Missing
`Plansets` has 37311 (18.8%) missing values	Missing
`TIDF Compliance` has 198908 (> 99.9%) missing values	Missing
`Existing Construction Type` has 43369 (21.8%) missing values	Missing
`Existing Construction Type Description` has 43370 (21.8%) missing values	Missing
`Proposed Construction Type` has 43165 (21.7%) missing values	Missing
`Proposed Construction Type Description` has 43165 (21.7%) missing values	Missing
`Site Permit` has 193550 (97.3%) missing values	Missing
`Estimated Cost` is highly skewed (γ1 = 80.2643549)	Skewed
`Revised Cost` is highly skewed (γ1 = 108.7016029)	Skewed
`Plansets` is highly skewed (γ1 = 400.8420748)	Skewed
`Existing Construction Type` is highly skewed (γ1 = 35.25093762)	Skewed
`Supervisor District` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Unit` has 21411 (10.8%) zeros	Zeros
`Revised Cost` has 8514 (4.3%) zeros	Zeros
`Existing Units` has 29135 (14.6%) zeros	Zeros
`Proposed Units` has 26885 (13.5%) zeros	Zeros
`Plansets` has 63247 (31.8%) zeros	Zeros

Reproduction

Analysis started	2024-08-30 23:21:19.727303
Analysis finished	2024-08-30 23:24:01.890480
Duration	2 minutes and 42.16 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

Permit Number
Text

Distinct	181495
Distinct (%)	91.2%
Missing	0
Missing (%)	0.0%
Memory size	12.9 MiB

Length

Max length	12
Median length	12
Mean length	11.06327
Min length	7

Characters and Unicode

Total characters	2200595
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	167272 ?
Unique (%)	84.1%

Sample

1st row	M788927
2nd row	201305318356
3rd row	201705106205
4th row	201410279983
5th row	201310280388

Value	Count	Frequency (%)
201602179765	101	0.1%
201602179758	66	< 0.1%
201602179775	30	< 0.1%
201708165004	9	< 0.1%
201702239990	9	< 0.1%
201409166451	9	< 0.1%
201707061162	8	< 0.1%
201604285989	8	< 0.1%
201702099112	8	< 0.1%
201602179774	8	< 0.1%
Other values (181485)	198654	99.9%

Most occurring characters

Value	Count	Frequency (%)
0	445644	20.3%
1	376248	17.1%
2	338899	15.4%
7	174090	7.9%
6	150955	6.9%
4	147674	6.7%
3	145535	6.6%
5	144933	6.6%
8	130430	5.9%
9	108922	4.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2200595	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	445644	20.3%
1	376248	17.1%
2	338899	15.4%
7	174090	7.9%
6	150955	6.9%
4	147674	6.7%
3	145535	6.6%
5	144933	6.6%
8	130430	5.9%
9	108922	4.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2200595	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	445644	20.3%
1	376248	17.1%
2	338899	15.4%
7	174090	7.9%
6	150955	6.9%
4	147674	6.7%
3	145535	6.6%
5	144933	6.6%
8	130430	5.9%
9	108922	4.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2200595	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	445644	20.3%
1	376248	17.1%
2	338899	15.4%
7	174090	7.9%
6	150955	6.9%
4	147674	6.7%
3	145535	6.6%
5	144933	6.6%
8	130430	5.9%
9	108922	4.9%

Permit Type
Real number (ℝ)

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.5222865

Minimum	1
Maximum	8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	8
median	8
Q3	8
95-th percentile	8
Maximum	8
Range	7
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	1.457526
Coefficient of variation (CV)	0.19376103
Kurtosis	6.036264
Mean	7.5222865
Median Absolute Deviation (MAD)	0
Skewness	-2.79896
Sum	1496258
Variance	2.124382
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
8	178852	89.9%
3	14664	7.4%
4	2892	1.5%
2	950	0.5%
6	600	0.3%
7	511	0.3%
1	350	0.2%
5	91	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	350	0.2%
2	950	0.5%
3	14664	7.4%
4	2892	1.5%
5	91	< 0.1%
6	600	0.3%
7	511	0.3%
8	178852	89.9%

Value	Count	Frequency (%)
8	178852	89.9%
7	511	0.3%
6	600	0.3%
5	91	< 0.1%
4	2892	1.5%
3	14664	7.4%
2	950	0.5%
1	350	0.2%

Permit Type Definition
Categorical

HIGH CORRELATION IMBALANCE

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	15.1 MiB

otc alterations permit	178836
additions alterations or repairs	14663
sign - erect	2892
new construction wood frame	950
demolitions	600
Other values (8)	969

Length

Max length	35
Median length	22
Mean length	22.572978
Min length	11

Characters and Unicode

Total characters	4489991
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	otc alterations permit
2nd row	otc alterations permit
3rd row	otc alterations permit
4th row	otc alterations permit
5th row	otc alterations permit

Common Values

Value	Count	Frequency (%)
otc alterations permit	178836	89.9%
additions alterations or repairs	14663	7.4%
sign - erect	2892	1.5%
new construction wood frame	950	0.5%
demolitions	600	0.3%
wall or painted sign	511	0.3%
new construction	347	0.2%
grade or quarry or fill or excavate	91	< 0.1%
otc alterations permit	8	< 0.1%
otc alterations permit #	8	< 0.1%
Other values (3)	4	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
alterations	193516	31.6%
otc	178852	29.2%
permit	178852	29.2%
or	15448	2.5%
additions	14664	2.4%
repairs	14664	2.4%
sign	3403	0.6%
	2902	0.5%
erect	2892	0.5%
construction	1300	0.2%
Other values (10)	5186	0.8%

Most occurring characters

Value	Count	Frequency (%)
t	766094	17.1%
i	422865	9.4%
r	422559	9.4%
a	418696	9.3%
	412789	9.2%
o	408180	9.1%
e	396450	8.8%
s	228147	5.1%
n	216594	4.8%
l	195320	4.4%
Other values (14)	602297	13.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4489991	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	766094	17.1%
i	422865	9.4%
r	422559	9.4%
a	418696	9.3%
	412789	9.2%
o	408180	9.1%
e	396450	8.8%
s	228147	5.1%
n	216594	4.8%
l	195320	4.4%
Other values (14)	602297	13.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4489991	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	766094	17.1%
i	422865	9.4%
r	422559	9.4%
a	418696	9.3%
	412789	9.2%
o	408180	9.1%
e	396450	8.8%
s	228147	5.1%
n	216594	4.8%
l	195320	4.4%
Other values (14)	602297	13.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4489991	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	766094	17.1%
i	422865	9.4%
r	422559	9.4%
a	418696	9.3%
	412789	9.2%
o	408180	9.1%
e	396450	8.8%
s	228147	5.1%
n	216594	4.8%
l	195320	4.4%
Other values (14)	602297	13.4%

Permit Creation Date
Date

Distinct	1291
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2012-03-28 00:00:00
Maximum	2018-02-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Block
Text

Distinct	4896
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Memory size	11.6 MiB

Length

Max length	5
Median length	4
Mean length	4.0363933
Min length	3

Characters and Unicode

Total characters	802879
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	124 ?
Unique (%)	0.1%

Sample

1st row	0215
2nd row	1810
3rd row	5700
4th row	0661
5th row	3642

Value	Count	Frequency (%)
3708	1195	0.6%
3735	750	0.4%
7331	680	0.3%
0289	640	0.3%
3709	584	0.3%
3717	578	0.3%
3707	576	0.3%
3721	567	0.3%
3706	561	0.3%
0259	554	0.3%
Other values (4886)	192225	96.6%

Most occurring characters

Value	Count	Frequency (%)
0	124327	15.5%
3	97524	12.1%
1	96595	12.0%
2	85374	10.6%
5	80950	10.1%
6	77737	9.7%
7	73548	9.2%
4	60017	7.5%
8	50674	6.3%
9	48902	6.1%
Other values (9)	7231	0.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	802879	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	124327	15.5%
3	97524	12.1%
1	96595	12.0%
2	85374	10.6%
5	80950	10.1%
6	77737	9.7%
7	73548	9.2%
4	60017	7.5%
8	50674	6.3%
9	48902	6.1%
Other values (9)	7231	0.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	802879	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	124327	15.5%
3	97524	12.1%
1	96595	12.0%
2	85374	10.6%
5	80950	10.1%
6	77737	9.7%
7	73548	9.2%
4	60017	7.5%
8	50674	6.3%
9	48902	6.1%
Other values (9)	7231	0.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	802879	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	124327	15.5%
3	97524	12.1%
1	96595	12.0%
2	85374	10.6%
5	80950	10.1%
6	77737	9.7%
7	73548	9.2%
4	60017	7.5%
8	50674	6.3%
9	48902	6.1%
Other values (9)	7231	0.9%

Lot
Text

Distinct	1055
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	11.4 MiB

Length

Max length	4
Median length	3
Mean length	3.0798753
Min length	3

Characters and Unicode

Total characters	612618
Distinct characters	36
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	180 ?
Unique (%)	0.1%

Sample

1st row	001
2nd row	017A
3rd row	027
4th row	005
5th row	051A

Value	Count	Frequency (%)
001	10116	5.1%
007	5317	2.7%
002	5184	2.6%
003	5042	2.5%
006	4835	2.4%
008	4773	2.4%
009	4590	2.3%
005	4549	2.3%
004	4384	2.2%
011	4238	2.1%
Other values (1045)	145882	73.3%

Most occurring characters

Value	Count	Frequency (%)
0	266819	43.6%
1	80415	13.1%
2	59437	9.7%
3	43028	7.0%
4	33218	5.4%
5	26863	4.4%
6	25008	4.1%
7	22210	3.6%
8	20304	3.3%
9	19441	3.2%
Other values (26)	15875	2.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	612618	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	266819	43.6%
1	80415	13.1%
2	59437	9.7%
3	43028	7.0%
4	33218	5.4%
5	26863	4.4%
6	25008	4.1%
7	22210	3.6%
8	20304	3.3%
9	19441	3.2%
Other values (26)	15875	2.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	612618	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	266819	43.6%
1	80415	13.1%
2	59437	9.7%
3	43028	7.0%
4	33218	5.4%
5	26863	4.4%
6	25008	4.1%
7	22210	3.6%
8	20304	3.3%
9	19441	3.2%
Other values (26)	15875	2.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	612618	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	266819	43.6%
1	80415	13.1%
2	59437	9.7%
3	43028	7.0%
4	33218	5.4%
5	26863	4.4%
6	25008	4.1%
7	22210	3.6%
8	20304	3.3%
9	19441	3.2%
Other values (26)	15875	2.6%

Street Number
Real number (ℝ)

Distinct	5099
Distinct (%)	2.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1121.7155

Minimum	0
Maximum	8400
Zeros	4
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	32
Q1	235
median	710
Q3	1700
95-th percentile	3481
Maximum	8400
Range	8400
Interquartile range (IQR)	1465

Descriptive statistics

Standard deviation	1135.7985
Coefficient of variation (CV)	1.0125548
Kurtosis	2.1350541
Mean	1121.7155
Median Absolute Deviation (MAD)	580
Skewness	1.4269693
Sum	2.2312044 × 10⁸
Variance	1290038.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2398	1.2%
101	1153	0.6%
100	1143	0.6%
50	1103	0.6%
201	1026	0.5%
555	994	0.5%
2	814	0.4%
55	734	0.4%
350	705	0.4%
150	672	0.3%
Other values (5089)	188168	94.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	< 0.1%
1	2398	1.2%
2	814	0.4%
3	309	0.2%
4	255	0.1%
5	194	0.1%
6	113	0.1%
7	132	0.1%
8	281	0.1%
9	128	0.1%

Value	Count	Frequency (%)
8400	3	< 0.1%
8331	1	< 0.1%
8325	5	< 0.1%
8320	1	< 0.1%
8300	1	< 0.1%
8245	1	< 0.1%
8231	1	< 0.1%
8228	1	< 0.1%
8222	7	< 0.1%
8219	1	< 0.1%

Street Number Suffix
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	18
Distinct (%)	0.8%
Missing	196694
Missing (%)	98.9%
Memory size	10.6 MiB

A	1501
B	291
V	228
C	56
E	28
Other values (13)	112

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	2216
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.1%

Sample

1st row	B
2nd row	A
3rd row	V
4th row	A
5th row	V

Common Values

Value	Count	Frequency (%)
A	1501	0.8%
B	291	0.1%
V	228	0.1%
C	56	< 0.1%
E	28	< 0.1%
F	24	< 0.1%
G	12	< 0.1%
D	11	< 0.1%
H	11	< 0.1%
K	11	< 0.1%
Other values (8)	43	< 0.1%
(Missing)	196694	98.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
a	1501	67.7%
b	291	13.1%
v	228	10.3%
c	56	2.5%
e	28	1.3%
f	24	1.1%
g	12	0.5%
h	11	0.5%
k	11	0.5%
d	11	0.5%
Other values (8)	43	1.9%

Most occurring characters

Value	Count	Frequency (%)
A	1501	67.7%
B	291	13.1%
V	228	10.3%
C	56	2.5%
E	28	1.3%
F	24	1.1%
G	12	0.5%
H	11	0.5%
K	11	0.5%
D	11	0.5%
Other values (8)	43	1.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2216	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	1501	67.7%
B	291	13.1%
V	228	10.3%
C	56	2.5%
E	28	1.3%
F	24	1.1%
G	12	0.5%
H	11	0.5%
K	11	0.5%
D	11	0.5%
Other values (8)	43	1.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2216	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	1501	67.7%
B	291	13.1%
V	228	10.3%
C	56	2.5%
E	28	1.3%
F	24	1.1%
G	12	0.5%
H	11	0.5%
K	11	0.5%
D	11	0.5%
Other values (8)	43	1.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2216	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	1501	67.7%
B	291	13.1%
V	228	10.3%
C	56	2.5%
E	28	1.3%
F	24	1.1%
G	12	0.5%
H	11	0.5%
K	11	0.5%
D	11	0.5%
Other values (8)	43	1.9%

Street Name
Text

Distinct	1714
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Memory size	12.0 MiB

Length

Max length	25
Median length	22
Mean length	6.5098185
Min length	3

Characters and Unicode

Total characters	1294868
Distinct characters	65
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	117 ?
Unique (%)	0.1%

Sample

1st row	jOnEs
2nd row	43rD
3rd row	pReNtIsS
4th row	bUsH
5th row	cApP

Value	Count	Frequency (%)
market	5443	2.6%
california	4587	2.2%
mission	4324	2.0%
montgomery	2933	1.4%
geary	1966	0.9%
20th	1859	0.9%
03rd	1819	0.9%
folsom	1776	0.8%
van	1698	0.8%
pine	1678	0.8%
Other values (1705)	184679	86.8%

Most occurring characters

Value	Count	Frequency (%)
A	83888	6.5%
O	63275	4.9%
e	55861	4.3%
n	55448	4.3%
r	54146	4.2%
E	54117	4.2%
t	51943	4.0%
s	49681	3.8%
R	45151	3.5%
T	42390	3.3%
Other values (55)	738968	57.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1294868	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	83888	6.5%
O	63275	4.9%
e	55861	4.3%
n	55448	4.3%
r	54146	4.2%
E	54117	4.2%
t	51943	4.0%
s	49681	3.8%
R	45151	3.5%
T	42390	3.3%
Other values (55)	738968	57.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1294868	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	83888	6.5%
O	63275	4.9%
e	55861	4.3%
n	55448	4.3%
r	54146	4.2%
E	54117	4.2%
t	51943	4.0%
s	49681	3.8%
R	45151	3.5%
T	42390	3.3%
Other values (55)	738968	57.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1294868	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	83888	6.5%
O	63275	4.9%
e	55861	4.3%
n	55448	4.3%
r	54146	4.2%
E	54117	4.2%
t	51943	4.0%
s	49681	3.8%
R	45151	3.5%
T	42390	3.3%
Other values (55)	738968	57.1%

Street Suffix
Categorical

IMBALANCE MISSING

Distinct	21
Distinct (%)	< 0.1%
Missing	2768
Missing (%)	1.4%
Memory size	11.2 MiB

St	138365
Av	43222
Bl	3555
Wy	3540
Dr	3267
Other values (16)	4193

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	392284
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	St
2nd row	Av
3rd row	St
4th row	St
5th row	St

Common Values

Value	Count	Frequency (%)
St	138365	69.6%
Av	43222	21.7%
Bl	3555	1.8%
Wy	3540	1.8%
Dr	3267	1.6%
Tr	1466	0.7%
Ct	667	0.3%
Pl	538	0.3%
Rd	389	0.2%
Ln	354	0.2%
Other values (11)	779	0.4%
(Missing)	2768	1.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
st	138365	70.5%
av	43222	22.0%
bl	3555	1.8%
wy	3540	1.8%
dr	3267	1.7%
tr	1466	0.7%
ct	667	0.3%
pl	538	0.3%
rd	389	0.2%
ln	354	0.2%
Other values (11)	779	0.4%

Most occurring characters

Value	Count	Frequency (%)
t	139032	35.4%
S	138369	35.3%
A	43305	11.0%
v	43222	11.0%
r	4830	1.2%
l	4177	1.1%
y	3780	1.0%
B	3555	0.9%
W	3549	0.9%
D	3267	0.8%
Other values (13)	5198	1.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	392284	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
t	139032	35.4%
S	138369	35.3%
A	43305	11.0%
v	43222	11.0%
r	4830	1.2%
l	4177	1.1%
y	3780	1.0%
B	3555	0.9%
W	3549	0.9%
D	3267	0.8%
Other values (13)	5198	1.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	392284	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
t	139032	35.4%
S	138369	35.3%
A	43305	11.0%
v	43222	11.0%
r	4830	1.2%
l	4177	1.1%
y	3780	1.0%
B	3555	0.9%
W	3549	0.9%
D	3267	0.8%
Other values (13)	5198	1.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	392284	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
t	139032	35.4%
S	138369	35.3%
A	43305	11.0%
v	43222	11.0%
r	4830	1.2%
l	4177	1.1%
y	3780	1.0%
B	3555	0.9%
W	3549	0.9%
D	3267	0.8%
Other values (13)	5198	1.3%

Unit
Real number (ℝ)

MISSING ZEROS

Distinct	660
Distinct (%)	2.2%
Missing	169430
Missing (%)	85.2%
Infinite	0
Infinite (%)	0.0%
Mean	78.514518

Minimum	0
Maximum	6004
Zeros	21411
Zeros (%)	10.8%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	446.1
Maximum	6004
Range	6004
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	326.9761
Coefficient of variation (CV)	4.1645304
Kurtosis	92.15637
Mean	78.514518
Median Absolute Deviation (MAD)	0
Skewness	8.1334162
Sum	2314608
Variance	106913.37
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	21411	10.8%
1	1312	0.7%
2	549	0.3%
3	448	0.2%
101	365	0.2%
4	288	0.1%
6	214	0.1%
5	211	0.1%
201	210	0.1%
8	104	0.1%
Other values (650)	4368	2.2%
(Missing)	169430	85.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	21411	10.8%
1	1312	0.7%
2	549	0.3%
3	448	0.2%
4	288	0.1%
5	211	0.1%
6	214	0.1%
7	103	0.1%
8	104	0.1%
9	69	< 0.1%

Value	Count	Frequency (%)
6004	1	< 0.1%
6003	3	< 0.1%
5903	1	< 0.1%
5604	1	< 0.1%
5602	1	< 0.1%
5413	1	< 0.1%
5412	1	< 0.1%
5313	1	< 0.1%
5312	1	< 0.1%
5306	1	< 0.1%

Unit Suffix
Text

MISSING

Distinct	164
Distinct (%)	8.4%
Missing	196949
Missing (%)	99.0%
Memory size	6.1 MiB

Length

Max length	10
Median length	1
Mean length	2.6017338
Min length	1

Characters and Unicode

Total characters	5102
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	60 ?
Unique (%)	3.1%

Sample

1st row	C
2nd row	C
3rd row	RESID'L
4th row	D
5th row	E

Value	Count	Frequency (%)
a	354	16.5%
c	229	10.7%
b	199	9.3%
d	137	6.4%
e	93	4.3%
bldg	93	4.3%
hoa	85	4.0%
f	78	3.6%
comml	51	2.4%
front	48	2.2%
Other values (135)	782	36.4%

Most occurring characters

Value	Count	Frequency (%)
A	545	10.7%
C	409	8.0%
E	321	6.3%
B	315	6.2%
R	311	6.1%
D	295	5.8%
O	264	5.2%
L	261	5.1%
F	208	4.1%
	188	3.7%
Other values (36)	1985	38.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5102	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	545	10.7%
C	409	8.0%
E	321	6.3%
B	315	6.2%
R	311	6.1%
D	295	5.8%
O	264	5.2%
L	261	5.1%
F	208	4.1%
	188	3.7%
Other values (36)	1985	38.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5102	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	545	10.7%
C	409	8.0%
E	321	6.3%
B	315	6.2%
R	311	6.1%
D	295	5.8%
O	264	5.2%
L	261	5.1%
F	208	4.1%
	188	3.7%
Other values (36)	1985	38.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5102	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	545	10.7%
C	409	8.0%
E	321	6.3%
B	315	6.2%
R	311	6.1%
D	295	5.8%
O	264	5.2%
L	261	5.1%
F	208	4.1%
	188	3.7%
Other values (36)	1985	38.9%

Description
Text

Distinct	134272
Distinct (%)	67.6%
Missing	290
Missing (%)	0.1%
Memory size	30.0 MiB

Length

Max length	300
Median length	243
Mean length	101.45318
Min length	1

Characters and Unicode

Total characters	20150631
Distinct characters	76
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	122032 ?
Unique (%)	61.4%

Sample

1st row	street space
2nd row	remodel kitchen: replace countertop, cabinets, sink, stove, hardwood floor & lighting.
3rd row	replacement of 4 windows; 2 located in lightwell and 2 at front. replaceing existing vinyl windows with new wood-clad windows. no horizontal mullion in living room window
4th row	two kitchens & two bathrooms remodel. replace kitchen cabinets, countertops & appliances in same location. replace tub & faucet & vanity & tile in same location in both units.
5th row	reroofing

Value	Count	Frequency (%)
	94921	3.0%
to	93338	2.9%
and	68894	2.2%
new	61786	1.9%
of	54700	1.7%
street	44273	1.4%
space	41100	1.3%
replace	36545	1.1%
in	36109	1.1%
for	35061	1.1%
Other values (109535)	2636742	82.3%

Most occurring characters

Value	Count	Frequency (%)
	3042851	15.1%
e	1735300	8.6%
o	1280056	6.4%
r	1277846	6.3%
t	1208273	6.0%
n	1153984	5.7%
a	1149599	5.7%
i	1122199	5.6%
s	828425	4.1%
l	785552	3.9%
Other values (66)	6566546	32.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	20150631	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	3042851	15.1%
e	1735300	8.6%
o	1280056	6.4%
r	1277846	6.3%
t	1208273	6.0%
n	1153984	5.7%
a	1149599	5.7%
i	1122199	5.6%
s	828425	4.1%
l	785552	3.9%
Other values (66)	6566546	32.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	20150631	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	3042851	15.1%
e	1735300	8.6%
o	1280056	6.4%
r	1277846	6.3%
t	1208273	6.0%
n	1153984	5.7%
a	1149599	5.7%
i	1122199	5.6%
s	828425	4.1%
l	785552	3.9%
Other values (66)	6566546	32.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	20150631	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	3042851	15.1%
e	1735300	8.6%
o	1280056	6.4%
r	1277846	6.3%
t	1208273	6.0%
n	1153984	5.7%
a	1149599	5.7%
i	1122199	5.6%
s	828425	4.1%
l	785552	3.9%
Other values (66)	6566546	32.6%

Current Status
Categorical

IMBALANCE

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.1 MiB

complete	97081
issued	83563
filed	12045
withdrawn	1754
cancelled	1536
Other values (9)	2931

Length

Max length	11
Median length	10
Mean length	6.9923282
Min length	5

Characters and Unicode

Total characters	1390844
Distinct characters	20
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	issued
2nd row	complete
3rd row	issued
4th row	complete
5th row	issued

Common Values

Value	Count	Frequency (%)
complete	97081	48.8%
issued	83563	42.0%
filed	12045	6.1%
withdrawn	1754	0.9%
cancelled	1536	0.8%
expired	1370	0.7%
approved	733	0.4%
reinstated	563	0.3%
suspend	193	0.1%
revoked	50	< 0.1%
Other values (4)	22	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
complete	97081	48.8%
issued	83563	42.0%
filed	12045	6.1%
withdrawn	1754	0.9%
cancelled	1536	0.8%
expired	1370	0.7%
approved	733	0.4%
reinstated	563	0.3%
suspend	193	0.1%
revoked	50	< 0.1%
Other values (4)	22	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	297758	21.4%
s	168077	12.1%
l	112218	8.1%
d	101811	7.3%
c	100187	7.2%
p	100136	7.2%
t	99963	7.2%
i	99299	7.1%
o	97868	7.0%
m	97083	7.0%
Other values (10)	116444	8.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1390844	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	297758	21.4%
s	168077	12.1%
l	112218	8.1%
d	101811	7.3%
c	100187	7.2%
p	100136	7.2%
t	99963	7.2%
i	99299	7.1%
o	97868	7.0%
m	97083	7.0%
Other values (10)	116444	8.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1390844	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	297758	21.4%
s	168077	12.1%
l	112218	8.1%
d	101811	7.3%
c	100187	7.2%
p	100136	7.2%
t	99963	7.2%
i	99299	7.1%
o	97868	7.0%
m	97083	7.0%
Other values (10)	116444	8.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1390844	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	297758	21.4%
s	168077	12.1%
l	112218	8.1%
d	101811	7.3%
c	100187	7.2%
p	100136	7.2%
t	99963	7.2%
i	99299	7.1%
o	97868	7.0%
m	97083	7.0%
Other values (10)	116444	8.4%

Current Status Date
Date

Distinct	1307
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2013-01-02 00:00:00
Maximum	2019-03-02 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Filed Date
Date

Distinct	1288
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.5 MiB

Minimum	2013-01-02 00:00:00
Maximum	2018-02-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Issued Date
Date

MISSING

Distinct	1289
Distinct (%)	0.7%
Missing	14942
Missing (%)	7.5%
Memory size	1.5 MiB

Minimum	2013-01-02 00:00:00
Maximum	2018-02-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Completed Date
Date

MISSING

Distinct	1300
Distinct (%)	1.3%
Missing	101715
Missing (%)	51.1%
Memory size	1.5 MiB

Minimum	2013-01-04 00:00:00
Maximum	2018-02-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

First Construction Document Date
Date

MISSING

Distinct	1288
Distinct (%)	0.7%
Missing	14948
Missing (%)	7.5%
Memory size	1.5 MiB

Minimum	2013-01-02 00:00:00
Maximum	2018-02-23 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Structural Notification
Boolean

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	191988
Missing (%)	96.5%
Memory size	388.6 KiB

True	6922
(Missing)	191988

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	6922	3.5%
(Missing)	191988	96.5%

Number of Existing Stories
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	64
Distinct (%)	< 0.1%
Missing	42788
Missing (%)	21.5%
Infinite	0
Infinite (%)	0.0%
Mean	5.7057077

Minimum	0
Maximum	78
Zeros	442
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	26
Maximum	78
Range	78
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	8.6133098
Coefficient of variation (CV)	1.5095953
Kurtosis	11.309873
Mean	5.7057077
Median Absolute Deviation (MAD)	1
Skewness	3.2978123
Sum	890786.5
Variance	74.189106
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	52770	26.5%
3	45741	23.0%
4	16055	8.1%
1	8793	4.4%
5	3767	1.9%
6	3696	1.9%
7	2359	1.2%
8	1732	0.9%
9	1264	0.6%
10	1129	0.6%
Other values (54)	18816	9.5%
(Missing)	42788	21.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	442	0.2%
1	8793	4.4%
1.5	1	< 0.1%
2	52770	26.5%
2.5	2	< 0.1%
3	45741	23.0%
4	16055	8.1%
5	3767	1.9%
6	3696	1.9%
7	2359	1.2%

Value	Count	Frequency (%)
78	1	< 0.1%
63	99	< 0.1%
62	2	< 0.1%
61	24	< 0.1%
60	18	< 0.1%
58	93	< 0.1%
56	4	< 0.1%
55	14	< 0.1%
54	7	< 0.1%
53	12	< 0.1%

Number of Proposed Stories
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	64
Distinct (%)	< 0.1%
Missing	42871
Missing (%)	21.6%
Infinite	0
Infinite (%)	0.0%
Mean	5.7449644

Minimum	0
Maximum	78
Zeros	174
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	26
Maximum	78
Range	78
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	8.6131126
Coefficient of variation (CV)	1.4992456
Kurtosis	11.46678
Mean	5.7449644
Median Absolute Deviation (MAD)	1
Skewness	3.3179006
Sum	896438.5
Variance	74.185708
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	50994	25.6%
3	46803	23.5%
4	17594	8.8%
1	7893	4.0%
5	4044	2.0%
6	3792	1.9%
7	2318	1.2%
8	1703	0.9%
9	1334	0.7%
11	1120	0.6%
Other values (54)	18444	9.3%
(Missing)	42871	21.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	174	0.1%
1	7893	4.0%
1.5	1	< 0.1%
2	50994	25.6%
2.5	2	< 0.1%
3	46803	23.5%
4	17594	8.8%
5	4044	2.0%
6	3792	1.9%
7	2318	1.2%

Value	Count	Frequency (%)
78	1	< 0.1%
63	105	0.1%
62	4	< 0.1%
61	24	< 0.1%
60	19	< 0.1%
58	90	< 0.1%
56	11	< 0.1%
55	23	< 0.1%
54	14	< 0.1%
53	12	< 0.1%

Voluntary Soft-Story Retrofit
Boolean

CONSTANT MISSING

Distinct	1
Distinct (%)	2.9%
Missing	198875
Missing (%)	> 99.9%
Memory size	388.6 KiB

True	35
(Missing)	198875

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	35	< 0.1%
(Missing)	198875	> 99.9%

Fire Only Permit
Boolean

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	180082
Missing (%)	90.5%
Memory size	388.6 KiB

True	18828
(Missing)	180082

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	18828	9.5%
(Missing)	180082	90.5%

Permit Expiration Date
Date

MISSING

Distinct	2232
Distinct (%)	1.5%
Missing	51884
Missing (%)	26.1%
Memory size	1.5 MiB

Minimum	2013-07-15 00:00:00
Maximum	2024-02-21 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Estimated Cost
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED

Distinct	11395
Distinct (%)	7.1%
Missing	38068
Missing (%)	19.1%
Infinite	0
Infinite (%)	0.0%
Mean	169009.86

Minimum	1
Maximum	5.3795865 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3300
median	11000
Q3	35000
95-th percentile	275000
Maximum	5.3795865 × 10⁸
Range	5.3795864 × 10⁸
Interquartile range (IQR)	31700

Descriptive statistics

Standard deviation	3630376.9
Coefficient of variation (CV)	21.480267
Kurtosis	8911.3386
Mean	169009.86
Median Absolute Deviation (MAD)	10000
Skewness	80.264355
Sum	2.7183884 × 10¹⁰
Variance	1.3179636 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	17014	8.6%
10000	6695	3.4%
5000	6437	3.2%
20000	5702	2.9%
15000	4779	2.4%
30000	3939	2.0%
25000	3599	1.8%
3000	3569	1.8%
50000	3345	1.7%
2000	3203	1.6%
Other values (11385)	102560	51.6%
(Missing)	38068	19.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	17014	8.6%
2	1	< 0.1%
4	2	< 0.1%
5	3	< 0.1%
10	11	< 0.1%
20	5	< 0.1%
25	7	< 0.1%
30	3	< 0.1%
35	1	< 0.1%
40	1	< 0.1%

Value	Count	Frequency (%)
537958646	1	< 0.1%
520000000	1	< 0.1%
400000000	2	< 0.1%
340000000	1	< 0.1%
272000000	1	< 0.1%
270000000	1	< 0.1%
239000000	1	< 0.1%
210000000	1	< 0.1%
175000000	1	< 0.1%
167000000	2	< 0.1%

Revised Cost
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	12629
Distinct (%)	6.5%
Missing	6066
Missing (%)	3.0%
Infinite	0
Infinite (%)	0.0%
Mean	132901.75

Minimum	0
Maximum	7.805 × 10⁸
Zeros	8514
Zeros (%)	4.3%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	7000
Q3	28715
95-th percentile	227340
Maximum	7.805 × 10⁸
Range	7.805 × 10⁸
Interquartile range (IQR)	28714

Descriptive statistics

Standard deviation	3584878.7
Coefficient of variation (CV)	26.973901
Kurtosis	17049.467
Mean	132901.75
Median Absolute Deviation (MAD)	6999
Skewness	108.7016
Sum	2.5629306 × 10¹⁰
Variance	1.2851355 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	47229	23.7%
0	8514	4.3%
10000	5474	2.8%
5000	5453	2.7%
20000	4696	2.4%
15000	4001	2.0%
30000	3291	1.7%
25000	3135	1.6%
3000	3067	1.5%
2000	2955	1.5%
Other values (12619)	105029	52.8%
(Missing)	6066	3.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8514	4.3%
0.01	1	< 0.1%
1	47229	23.7%
1.2	1	< 0.1%
2	4	< 0.1%
5	3	< 0.1%
10	11	< 0.1%
12	1	< 0.1%
13	1	< 0.1%
14	6	< 0.1%

Value	Count	Frequency (%)
780500000	1	< 0.1%
520000000	1	< 0.1%
400000000	2	< 0.1%
336200000	1	< 0.1%
270000000	1	< 0.1%
266061486	1	< 0.1%
239000000	1	< 0.1%
210000000	1	< 0.1%
207680000	1	< 0.1%
200000000	4	< 0.1%

Existing Use
Text

MISSING

Distinct	93
Distinct (%)	0.1%
Missing	41117
Missing (%)	20.7%
Memory size	11.8 MiB

Length

Max length	20
Median length	19
Mean length	13.170286
Min length	4

Characters and Unicode

Total characters	2078179
Distinct characters	39
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	1 family dwelling
2nd row	1 family dwelling
3rd row	2 family dwelling
4th row	apartments
5th row	apartments

Value	Count	Frequency (%)
family	67756	21.4%
dwelling	67756	21.4%
1	46768	14.8%
apartments	40800	12.9%
office	24617	7.8%
2	20988	6.6%
sales	7032	2.2%
retail	6910	2.2%
hndlng	4886	1.5%
food/beverage	4886	1.5%
Other values (144)	24040	7.6%

Most occurring characters

Value	Count	Frequency (%)
l	235150	11.3%
a	181738	8.7%
i	179803	8.7%
e	177532	8.5%
	158646	7.6%
n	129792	6.2%
f	123927	6.0%
m	113200	5.4%
t	108688	5.2%
d	81432	3.9%
Other values (29)	588271	28.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2078179	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	235150	11.3%
a	181738	8.7%
i	179803	8.7%
e	177532	8.5%
	158646	7.6%
n	129792	6.2%
f	123927	6.0%
m	113200	5.4%
t	108688	5.2%
d	81432	3.9%
Other values (29)	588271	28.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2078179	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	235150	11.3%
a	181738	8.7%
i	179803	8.7%
e	177532	8.5%
	158646	7.6%
n	129792	6.2%
f	123927	6.0%
m	113200	5.4%
t	108688	5.2%
d	81432	3.9%
Other values (29)	588271	28.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2078179	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	235150	11.3%
a	181738	8.7%
i	179803	8.7%
e	177532	8.5%
	158646	7.6%
n	129792	6.2%
f	123927	6.0%
m	113200	5.4%
t	108688	5.2%
d	81432	3.9%
Other values (29)	588271	28.3%

Existing Units
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	348
Distinct (%)	0.2%
Missing	51543
Missing (%)	25.9%
Infinite	0
Infinite (%)	0.0%
Mean	15.666006

Minimum	0
Maximum	1907
Zeros	29135
Zeros (%)	14.6%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	4
95-th percentile	64
Maximum	1907
Range	1907
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	74.47512
Coefficient of variation (CV)	4.7539316
Kurtosis	238.3122
Mean	15.666006
Median Absolute Deviation (MAD)	1
Skewness	12.867436
Sum	2308652.3
Variance	5546.5435
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	47347	23.8%
0	29135	14.6%
2	21805	11.0%
3	8616	4.3%
6	6066	3.0%
4	5364	2.7%
12	2535	1.3%
5	2347	1.2%
8	1728	0.9%
9	1188	0.6%
Other values (338)	21236	10.7%
(Missing)	51543	25.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	29135	14.6%
0.3	1	< 0.1%
1	47347	23.8%
2	21805	11.0%
3	8616	4.3%
4	5364	2.7%
5	2347	1.2%
6	6066	3.0%
7	1172	0.6%
8	1728	0.9%

Value	Count	Frequency (%)
1907	44	< 0.1%
1732	8	< 0.1%
1500	51	< 0.1%
1499	1	< 0.1%
1186	51	< 0.1%
1010	2	< 0.1%
1005	21	< 0.1%
1004	2	< 0.1%
1000	1	< 0.1%
948	1	< 0.1%

Proposed Use
Text

MISSING

Distinct	94
Distinct (%)	0.1%
Missing	42441
Missing (%)	21.3%
Memory size	11.8 MiB

Length

Max length	20
Median length	19
Mean length	13.208827
Min length	4

Characters and Unicode

Total characters	2066772
Distinct characters	39
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	1 family dwelling
2nd row	1 family dwelling
3rd row	2 family dwelling
4th row	apartments
5th row	apartments

Value	Count	Frequency (%)
family	68410	21.8%
dwelling	68410	21.8%
1	46348	14.8%
apartments	43035	13.7%
office	23963	7.7%
2	22062	7.0%
sales	5193	1.7%
retail	5079	1.6%
food/beverage	5053	1.6%
hndlng	5053	1.6%
Other values (146)	20614	6.6%

Most occurring characters

Value	Count	Frequency (%)
l	232125	11.2%
a	179985	8.7%
i	177628	8.6%
e	175966	8.5%
	156751	7.6%
n	130398	6.3%
f	123053	6.0%
m	116197	5.6%
t	107434	5.2%
d	82574	4.0%
Other values (29)	584661	28.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2066772	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
l	232125	11.2%
a	179985	8.7%
i	177628	8.6%
e	175966	8.5%
	156751	7.6%
n	130398	6.3%
f	123053	6.0%
m	116197	5.6%
t	107434	5.2%
d	82574	4.0%
Other values (29)	584661	28.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2066772	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
l	232125	11.2%
a	179985	8.7%
i	177628	8.6%
e	175966	8.5%
	156751	7.6%
n	130398	6.3%
f	123053	6.0%
m	116197	5.6%
t	107434	5.2%
d	82574	4.0%
Other values (29)	584661	28.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2066772	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
l	232125	11.2%
a	179985	8.7%
i	177628	8.6%
e	175966	8.5%
	156751	7.6%
n	130398	6.3%
f	123053	6.0%
m	116197	5.6%
t	107434	5.2%
d	82574	4.0%
Other values (29)	584661	28.3%

Proposed Units
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	368
Distinct (%)	0.2%
Missing	50915
Missing (%)	25.6%
Infinite	0
Infinite (%)	0.0%
Mean	16.510882

Minimum	0
Maximum	1911
Zeros	26885
Zeros (%)	13.5%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	2
Q3	4
95-th percentile	70
Maximum	1911
Range	1911
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	75.218997
Coefficient of variation (CV)	4.5557225
Kurtosis	223.71262
Mean	16.510882
Median Absolute Deviation (MAD)	1
Skewness	12.330487
Sum	2443528
Variance	5657.8975
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	46914	23.6%
0	26885	13.5%
2	22892	11.5%
3	9347	4.7%
6	5872	3.0%
4	5504	2.8%
12	2474	1.2%
5	2400	1.2%
8	1800	0.9%
7	1336	0.7%
Other values (358)	22571	11.3%
(Missing)	50915	25.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	26885	13.5%
1	46914	23.6%
2	22892	11.5%
3	9347	4.7%
4	5504	2.8%
5	2400	1.2%
6	5872	3.0%
7	1336	0.7%
8	1800	0.9%
9	1270	0.6%

Value	Count	Frequency (%)
1911	1	< 0.1%
1907	43	< 0.1%
1732	8	< 0.1%
1500	48	< 0.1%
1499	1	< 0.1%
1199	1	< 0.1%
1186	47	< 0.1%
1014	4	< 0.1%
1010	2	< 0.1%
1005	17	< 0.1%

Plansets
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED ZEROS

Distinct	8
Distinct (%)	< 0.1%
Missing	37311
Missing (%)	18.8%
Infinite	0
Infinite (%)	0.0%
Mean	1.274649

Minimum	0
Maximum	9000
Zeros	63247
Zeros (%)	31.8%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	2
95-th percentile	2
Maximum	9000
Range	9000
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	22.406792
Coefficient of variation (CV)	17.578794
Kurtosis	160982
Mean	1.274649
Median Absolute Deviation (MAD)	0
Skewness	400.84207
Sum	205982
Variance	502.06432
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	98093	49.3%
0	63247	31.8%
3	250	0.1%
4	3	< 0.1%
6	2	< 0.1%
1	2	< 0.1%
20	1	< 0.1%
9000	1	< 0.1%
(Missing)	37311	18.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	63247	31.8%
1	2	< 0.1%
2	98093	49.3%
3	250	0.1%
4	3	< 0.1%
6	2	< 0.1%
20	1	< 0.1%
9000	1	< 0.1%

Value	Count	Frequency (%)
9000	1	< 0.1%
20	1	< 0.1%
6	2	< 0.1%
4	3	< 0.1%
3	250	0.1%
2	98093	49.3%
1	2	< 0.1%
0	63247	31.8%

TIDF Compliance
Text

MISSING

Distinct	2
Distinct (%)	100.0%
Missing	198908
Missing (%)	> 99.9%
Memory size	6.1 MiB

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	2
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	100.0%

Sample

1st row	P
2nd row	Y

Value	Count	Frequency (%)
p	1	50.0%
y	1	50.0%

Most occurring characters

Value	Count	Frequency (%)
P	1	50.0%
Y	1	50.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
P	1	50.0%
Y	1	50.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
P	1	50.0%
Y	1	50.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
P	1	50.0%
Y	1	50.0%

Existing Construction Type
Real number (ℝ)

HIGH CORRELATION MISSING SKEWED

Distinct	7
Distinct (%)	< 0.1%
Missing	43369
Missing (%)	21.8%
Infinite	0
Infinite (%)	0.0%
Mean	4.7156312

Minimum	-99999
Maximum	99999
Zeros	0
Zeros (%)	0.0%
Negative	2
Negative (%)	< 0.1%
Memory size	1.5 MiB

Quantile statistics

Minimum	-99999
5-th percentile	1
Q1	3
median	5
Q3	5
95-th percentile	5
Maximum	99999
Range	199998
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	566.96662
Coefficient of variation (CV)	120.23133
Kurtosis	31105.634
Mean	4.7156312
Median Absolute Deviation (MAD)	0
Skewness	35.250938
Sum	733474
Variance	321451.15
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
5	113350	57.0%
1	28073	14.1%
3	9664	4.9%
2	4068	2.0%
4	381	0.2%
99999	3	< 0.1%
-99999	2	< 0.1%
(Missing)	43369	21.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-99999	2	< 0.1%
1	28073	14.1%
2	4068	2.0%
3	9664	4.9%
4	381	0.2%
5	113350	57.0%
99999	3	< 0.1%

Value	Count	Frequency (%)
99999	3	< 0.1%
5	113350	57.0%
4	381	0.2%
3	9664	4.9%
2	4068	2.0%
1	28073	14.1%
-99999	2	< 0.1%

Existing Construction Type Description
Categorical

HIGH CORRELATION IMBALANCE MISSING

Distinct	8
Distinct (%)	< 0.1%
Missing	43370
Missing (%)	21.8%
Memory size	12.8 MiB

wood frame (5)	113350
constr type 1	28072
constr type 3	9663
constr type 2	4068
constr type 4	381
Other values (3)	6

Length

Max length	16
Median length	14
Mean length	13.728854
Min length	13

Characters and Unicode

Total characters	2135386
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	wood frame (5)
2nd row	wood frame (5)
3rd row	wood frame (5)
4th row	wood frame (5)
5th row	wood frame (5)

Common Values

Value	Count	Frequency (%)
wood frame (5)	113350	57.0%
constr type 1	28072	14.1%
constr type 3	9663	4.9%
constr type 2	4068	2.0%
constr type 4	381	0.2%
wood frame (5)	4	< 0.1%
constr type 1	1	< 0.1%
constr type 3	1	< 0.1%
(Missing)	43370	21.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wood	113354	24.3%
frame	113354	24.3%
5	113354	24.3%
constr	42186	9.0%
type	42186	9.0%
1	28073	6.0%
3	9664	2.1%
2	4068	0.9%
4	381	0.1%

Most occurring characters

Value	Count	Frequency (%)
	311092	14.6%
o	268894	12.6%
e	155540	7.3%
r	155540	7.3%
w	113354	5.3%
5	113354	5.3%
(	113354	5.3%
)	113354	5.3%
m	113354	5.3%
a	113354	5.3%
Other values (12)	564196	26.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2135386	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	311092	14.6%
o	268894	12.6%
e	155540	7.3%
r	155540	7.3%
w	113354	5.3%
5	113354	5.3%
(	113354	5.3%
)	113354	5.3%
m	113354	5.3%
a	113354	5.3%
Other values (12)	564196	26.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2135386	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	311092	14.6%
o	268894	12.6%
e	155540	7.3%
r	155540	7.3%
w	113354	5.3%
5	113354	5.3%
(	113354	5.3%
)	113354	5.3%
m	113354	5.3%
a	113354	5.3%
Other values (12)	564196	26.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2135386	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	311092	14.6%
o	268894	12.6%
e	155540	7.3%
r	155540	7.3%
w	113354	5.3%
5	113354	5.3%
(	113354	5.3%
)	113354	5.3%
m	113354	5.3%
a	113354	5.3%
Other values (12)	564196	26.4%

Proposed Construction Type
Categorical

HIGH CORRELATION MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	43165
Missing (%)	21.7%
Memory size	11.2 MiB

5.0	114386
1.0	27843
3.0	9361
2.0	3778
4.0	377

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	467235
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5.0
2nd row	5.0
3rd row	5.0
4th row	5.0
5th row	5.0

Common Values

Value	Count	Frequency (%)
5.0	114386	57.5%
1.0	27843	14.0%
3.0	9361	4.7%
2.0	3778	1.9%
4.0	377	0.2%
(Missing)	43165	21.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
5.0	114386	73.4%
1.0	27843	17.9%
3.0	9361	6.0%
2.0	3778	2.4%
4.0	377	0.2%

Most occurring characters

Value	Count	Frequency (%)
.	155745	33.3%
0	155745	33.3%
5	114386	24.5%
1	27843	6.0%
3	9361	2.0%
2	3778	0.8%
4	377	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	467235	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
.	155745	33.3%
0	155745	33.3%
5	114386	24.5%
1	27843	6.0%
3	9361	2.0%
2	3778	0.8%
4	377	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	467235	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
.	155745	33.3%
0	155745	33.3%
5	114386	24.5%
1	27843	6.0%
3	9361	2.0%
2	3778	0.8%
4	377	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	467235	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
.	155745	33.3%
0	155745	33.3%
5	114386	24.5%
1	27843	6.0%
3	9361	2.0%
2	3778	0.8%
4	377	0.1%

Proposed Construction Type Description
Categorical

HIGH CORRELATION MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	43165
Missing (%)	21.7%
Memory size	12.8 MiB

wood frame (5)	114386
constr type 1	27843
constr type 3	9361
constr type 2	3778
constr type 4	377

Length

Max length	14
Median length	14
Mean length	13.734444
Min length	13

Characters and Unicode

Total characters	2139071
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	wood frame (5)
2nd row	wood frame (5)
3rd row	wood frame (5)
4th row	wood frame (5)
5th row	wood frame (5)

Common Values

Value	Count	Frequency (%)
wood frame (5)	114386	57.5%
constr type 1	27843	14.0%
constr type 3	9361	4.7%
constr type 2	3778	1.9%
constr type 4	377	0.2%
(Missing)	43165	21.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
wood	114386	24.5%
frame	114386	24.5%
5	114386	24.5%
constr	41359	8.9%
type	41359	8.9%
1	27843	6.0%
3	9361	2.0%
2	3778	0.8%
4	377	0.1%

Most occurring characters

Value	Count	Frequency (%)
	311490	14.6%
o	270131	12.6%
e	155745	7.3%
r	155745	7.3%
w	114386	5.3%
5	114386	5.3%
(	114386	5.3%
)	114386	5.3%
m	114386	5.3%
a	114386	5.3%
Other values (12)	559644	26.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2139071	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	311490	14.6%
o	270131	12.6%
e	155745	7.3%
r	155745	7.3%
w	114386	5.3%
5	114386	5.3%
(	114386	5.3%
)	114386	5.3%
m	114386	5.3%
a	114386	5.3%
Other values (12)	559644	26.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2139071	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	311490	14.6%
o	270131	12.6%
e	155745	7.3%
r	155745	7.3%
w	114386	5.3%
5	114386	5.3%
(	114386	5.3%
)	114386	5.3%
m	114386	5.3%
a	114386	5.3%
Other values (12)	559644	26.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2139071	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	311490	14.6%
o	270131	12.6%
e	155745	7.3%
r	155745	7.3%
w	114386	5.3%
5	114386	5.3%
(	114386	5.3%
)	114386	5.3%
m	114386	5.3%
a	114386	5.3%
Other values (12)	559644	26.2%

Site Permit
Boolean

CONSTANT MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	193550
Missing (%)	97.3%
Memory size	388.6 KiB

True	5360
(Missing)	193550

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	5360	2.7%
(Missing)	193550	97.3%

Supervisor District
Unsupported

REJECTED UNSUPPORTED

Missing	1719
Missing (%)	0.9%
Memory size	7.4 MiB

Neighborhoods - Analysis Boundaries
Categorical

HIGH CORRELATION

Distinct	41
Distinct (%)	< 0.1%
Missing	1725
Missing (%)	0.9%
Memory size	13.6 MiB

Financial District/South Beach	21816
Mission	14682
Sunset/Parkside	10207
West of Twin Peaks	8740
Castro/Upper Market	8527
Other values (36)	133213

Length

Max length	30
Median length	18
Mean length	14.780977
Min length	6

Characters and Unicode

Total characters	2914587
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Nob Hill
2nd row	Sunset/Parkside
3rd row	Bernal Heights
4th row	Pacific Heights
5th row	Mission

Common Values

Value	Count	Frequency (%)
Financial District/South Beach	21816	11.0%
Mission	14682	7.4%
Sunset/Parkside	10207	5.1%
West of Twin Peaks	8740	4.4%
Castro/Upper Market	8527	4.3%
Pacific Heights	8508	4.3%
Marina	8244	4.1%
Outer Richmond	7855	3.9%
Noe Valley	7844	3.9%
South of Market	7573	3.8%
Other values (31)	93189	46.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
beach	25870	6.5%
financial	21816	5.5%
district/south	21816	5.5%
mission	19211	4.9%
heights	18661	4.7%
of	16313	4.1%
market	16100	4.1%
hill	15798	4.0%
valley	14233	3.6%
richmond	12313	3.1%
Other values (46)	212950	53.9%

Most occurring characters

Value	Count	Frequency (%)
i	281035	9.6%
e	234500	8.0%
a	203693	7.0%
n	198634	6.8%
	197896	6.8%
t	194569	6.7%
s	176846	6.1%
o	150144	5.2%
r	148187	5.1%
c	109199	3.7%
Other values (36)	1019884	35.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2914587	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	281035	9.6%
e	234500	8.0%
a	203693	7.0%
n	198634	6.8%
	197896	6.8%
t	194569	6.7%
s	176846	6.1%
o	150144	5.2%
r	148187	5.1%
c	109199	3.7%
Other values (36)	1019884	35.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2914587	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	281035	9.6%
e	234500	8.0%
a	203693	7.0%
n	198634	6.8%
	197896	6.8%
t	194569	6.7%
s	176846	6.1%
o	150144	5.2%
r	148187	5.1%
c	109199	3.7%
Other values (36)	1019884	35.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2914587	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	281035	9.6%
e	234500	8.0%
a	203693	7.0%
n	198634	6.8%
	197896	6.8%
t	194569	6.7%
s	176846	6.1%
o	150144	5.2%
r	148187	5.1%
c	109199	3.7%
Other values (36)	1019884	35.0%

Zipcode
Real number (ℝ)

HIGH CORRELATION

Distinct	27
Distinct (%)	< 0.1%
Missing	1716
Missing (%)	0.9%
Infinite	0
Infinite (%)	0.0%
Mean	94115.501

Minimum	94102
Maximum	94158
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	94102
5-th percentile	94103
Q1	94109
median	94114
Q3	94122
95-th percentile	94133
Maximum	94158
Range	56
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	9.2701045
Coefficient of variation (CV)	9.8497107 × 10^-5
Kurtosis	1.2263383
Mean	94115.501
Median Absolute Deviation (MAD)	6
Skewness	0.85171252
Sum	1.8559012 × 10¹⁰
Variance	85.934838
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=27)

Value	Count	Frequency (%)
94110	17838	9.0%
94114	13404	6.7%
94117	11781	5.9%
94109	11348	5.7%
94103	10988	5.5%
94115	10095	5.1%
94118	9813	4.9%
94123	9515	4.8%
94122	8886	4.5%
94105	8628	4.3%
Other values (17)	84898	42.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
94102	7164	3.6%
94103	10988	5.5%
94104	4229	2.1%
94105	8628	4.3%
94107	7706	3.9%
94108	5321	2.7%
94109	11348	5.7%
94110	17838	9.0%
94111	5385	2.7%
94112	7898	4.0%

Value	Count	Frequency (%)
94158	1058	0.5%
94134	2983	1.5%
94133	7424	3.7%
94132	3507	1.8%
94131	7665	3.9%
94130	81	< 0.1%
94129	23	< 0.1%
94127	4993	2.5%
94124	5266	2.6%
94123	9515	4.8%

Location
Text

Distinct	57604
Distinct (%)	29.2%
Missing	1700
Missing (%)	0.9%
Memory size	18.3 MiB

Length

Max length	41
Median length	40
Mean length	40.044278
Min length	35

Characters and Unicode

Total characters	7897132
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	26164 ?
Unique (%)	13.3%

Sample

1st row	(37.79362102799777, -122.41488237355445)
2nd row	(37.759041020475465, -122.50286985467523)
3rd row	(37.73778863007536, -122.41197863877355)
4th row	(37.78762264983362, -122.43099126735969)
5th row	(37.75275550565926, -122.41707462095194)

Value	Count	Frequency (%)
37.79226164705184	554	0.1%
122.4034859571375	554	0.1%
37.79294896659241	330	0.1%
122.39809861435491	330	0.1%
37.728556952954136	281	0.1%
122.47676641508518	281	0.1%
37.77523036414975	276	0.1%
122.4174703200545	276	0.1%
37.78977799888473	252	0.1%
122.40173648131338	252	0.1%
Other values (115177)	391034	99.1%

Most occurring characters

Value	Count	Frequency (%)
2	899264	11.4%
7	893479	11.3%
3	736584	9.3%
1	703929	8.9%
4	698318	8.8%
5	534319	6.8%
6	524243	6.6%
8	524195	6.6%
9	523487	6.6%
0	478844	6.1%
Other values (6)	1380470	17.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7897132	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	899264	11.4%
7	893479	11.3%
3	736584	9.3%
1	703929	8.9%
4	698318	8.8%
5	534319	6.8%
6	524243	6.6%
8	524195	6.6%
9	523487	6.6%
0	478844	6.1%
Other values (6)	1380470	17.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7897132	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	899264	11.4%
7	893479	11.3%
3	736584	9.3%
1	703929	8.9%
4	698318	8.8%
5	534319	6.8%
6	524243	6.6%
8	524195	6.6%
9	523487	6.6%
0	478844	6.1%
Other values (6)	1380470	17.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7897132	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	899264	11.4%
7	893479	11.3%
3	736584	9.3%
1	703929	8.9%
4	698318	8.8%
5	534319	6.8%
6	524243	6.6%
8	524195	6.6%
9	523487	6.6%
0	478844	6.1%
Other values (6)	1380470	17.5%

Record ID
Real number (ℝ)

Distinct	198900
Distinct (%)	> 99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1620463 × 10¹²

Minimum	1.2935322 × 10¹⁰
Maximum	1.4983421 × 10¹²
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.5 MiB

Quantile statistics

Minimum	1.2935322 × 10¹⁰
5-th percentile	1.3453409 × 10¹¹
Q1	1.3085657 × 10¹²
median	1.3718398 × 10¹²
Q3	1.434998 × 10¹²
95-th percentile	1.4859048 × 10¹²
Maximum	1.4983421 × 10¹²
Range	1.4854068 × 10¹²
Interquartile range (IQR)	1.2643222 × 10¹¹

Descriptive statistics

Standard deviation	4.9182197 × 10¹¹
Coefficient of variation (CV)	0.42323786
Kurtosis	0.55165918
Mean	1.1620463 × 10¹²
Median Absolute Deviation (MAD)	6.3217113 × 10¹⁰
Skewness	-1.5726861
Sum	2.3114262 × 10¹⁷
Variance	2.4188885 × 10²³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.415850502 × 10¹²	2	< 0.1%
1.317532663 × 10¹¹	2	< 0.1%
1.448683508 × 10¹²	2	< 0.1%
1.394751213 × 10¹²	2	< 0.1%
1.475973855 × 10¹¹	2	< 0.1%
1.301037451 × 10¹²	2	< 0.1%
1.410003156 × 10¹²	2	< 0.1%
1.350685167 × 10¹²	2	< 0.1%
1.344366188 × 10¹²	2	< 0.1%
1.414026241 × 10¹²	2	< 0.1%
Other values (198890)	198890	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.29353215 × 10¹⁰	1	< 0.1%
1.295722223 × 10¹⁰	1	< 0.1%
1.296226196 × 10¹⁰	1	< 0.1%
1.296342101 × 10¹⁰	1	< 0.1%
1.296629102 × 10¹⁰	1	< 0.1%
1.297286249 × 10¹⁰	1	< 0.1%
1.297668221 × 10¹⁰	1	< 0.1%
1.297846157 × 10¹⁰	1	< 0.1%
1.298230162 × 10¹⁰	1	< 0.1%
1.298784182 × 10¹⁰	1	< 0.1%

Value	Count	Frequency (%)
1.498342128 × 10¹²	1	< 0.1%
1.498341156 × 10¹²	1	< 0.1%
1.498339194 × 10¹²	1	< 0.1%
1.498338347 × 10¹²	1	< 0.1%
1.498337117 × 10¹²	1	< 0.1%
1.498336196 × 10¹²	1	< 0.1%
1.498335409 × 10¹²	1	< 0.1%
1.498334222 × 10¹²	1	< 0.1%
1.498331399 × 10¹²	1	< 0.1%
1.498330476 × 10¹²	1	< 0.1%

Auto

Heatmap
Table

	Current Status	Estimated Cost	Existing Construction Type	Existing Construction Type Description	Existing Units	Neighborhoods - Analysis Boundaries	Number of Existing Stories	Number of Proposed Stories	Permit Type	Permit Type Definition	Plansets	Proposed Construction Type	Proposed Construction Type Description	Proposed Units	Record ID	Revised Cost	Street Number	Street Number Suffix	Street Suffix	Unit	Zipcode
Current Status	1.000	0.015	0.000	0.028	0.000	0.039	0.023	0.023	0.135	0.103	0.000	0.032	0.032	0.002	0.106	0.015	0.018	0.173	0.026	0.000	0.027
Estimated Cost	0.015	1.000	-0.073	0.000	0.009	0.009	0.099	0.117	-0.208	0.149	0.259	0.021	0.021	0.008	0.025	0.884	-0.020	0.000	0.000	0.006	-0.030
Existing Construction Type	0.000	-0.073	1.000	0.000	0.263	0.000	-0.620	-0.624	0.006	0.000	-0.346	0.000	0.000	0.252	0.091	-0.081	0.221	1.000	0.000	-0.145	0.487
Existing Construction Type Description	0.028	0.000	0.000	1.000	0.115	0.326	0.307	0.311	0.070	0.401	0.000	0.994	0.994	0.115	0.085	0.000	0.094	0.073	0.111	0.118	0.248
Existing Units	0.000	0.009	0.263	0.115	1.000	0.131	0.185	0.168	0.005	0.007	-0.169	0.142	0.142	0.981	0.052	-0.004	0.167	0.000	0.063	0.438	0.049
Neighborhoods - Analysis Boundaries	0.039	0.009	0.000	0.326	0.131	1.000	0.275	0.278	0.093	0.071	0.000	0.426	0.426	0.132	0.368	0.008	0.322	0.224	0.211	0.120	0.770
Number of Existing Stories	0.023	0.099	-0.620	0.307	0.185	0.275	1.000	0.982	0.025	0.030	0.286	0.410	0.410	0.181	-0.109	0.099	-0.133	0.079	0.092	0.197	-0.411
Number of Proposed Stories	0.023	0.117	-0.624	0.311	0.168	0.278	0.982	1.000	-0.021	0.031	0.311	0.409	0.409	0.194	-0.106	0.110	-0.128	0.068	0.092	0.196	-0.413
Permit Type	0.135	-0.208	0.006	0.070	0.005	0.093	0.025	-0.021	1.000	1.000	-0.285	0.057	0.057	-0.069	-0.013	-0.243	-0.005	0.204	0.058	0.064	0.001
Permit Type Definition	0.103	0.149	0.000	0.401	0.007	0.071	0.030	0.031	1.000	1.000	0.000	0.049	0.049	0.015	0.023	0.162	0.015	0.204	0.044	0.000	0.043
Plansets	0.000	0.259	-0.346	0.000	-0.169	0.000	0.286	0.311	-0.285	0.000	1.000	0.000	0.000	-0.133	-0.015	0.233	-0.064	1.000	0.000	-0.189	-0.204
Proposed Construction Type	0.032	0.021	0.000	0.994	0.142	0.426	0.410	0.409	0.057	0.049	0.000	1.000	1.000	0.143	0.085	0.017	0.121	0.054	0.148	0.133	0.306
Proposed Construction Type Description	0.032	0.021	0.000	0.994	0.142	0.426	0.410	0.409	0.057	0.049	0.000	1.000	1.000	0.143	0.085	0.017	0.121	0.054	0.148	0.133	0.306
Proposed Units	0.002	0.008	0.252	0.115	0.981	0.132	0.181	0.194	-0.069	0.015	-0.133	0.143	0.143	1.000	0.053	-0.007	0.168	0.000	0.064	0.437	0.029
Record ID	0.106	0.025	0.091	0.085	0.052	0.368	-0.109	-0.106	-0.013	0.023	-0.015	0.085	0.085	0.053	1.000	-0.015	-0.023	0.284	0.094	-0.230	-0.003
Revised Cost	0.015	0.884	-0.081	0.000	-0.004	0.008	0.099	0.110	-0.243	0.162	0.233	0.017	0.017	-0.007	-0.015	1.000	-0.063	0.000	0.000	0.024	-0.029
Street Number	0.018	-0.020	0.221	0.094	0.167	0.322	-0.133	-0.128	-0.005	0.015	-0.064	0.121	0.121	0.168	-0.023	-0.063	1.000	0.104	0.119	-0.005	0.151
Street Number Suffix	0.173	0.000	1.000	0.073	0.000	0.224	0.079	0.068	0.204	0.204	1.000	0.054	0.054	0.000	0.284	0.000	0.104	1.000	0.078	0.000	0.195
Street Suffix	0.026	0.000	0.000	0.111	0.063	0.211	0.092	0.092	0.058	0.044	0.000	0.148	0.148	0.064	0.094	0.000	0.119	0.078	1.000	0.079	0.247
Unit	0.000	0.006	-0.145	0.118	0.438	0.120	0.197	0.196	0.064	0.000	-0.189	0.133	0.133	0.437	-0.230	0.024	-0.005	0.000	0.079	1.000	-0.060
Zipcode	0.027	-0.030	0.487	0.248	0.049	0.770	-0.411	-0.413	0.001	0.043	-0.204	0.306	0.306	0.029	-0.003	-0.029	0.151	0.195	0.247	-0.060	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	Permit Number	Permit Type	Permit Type Definition	Permit Creation Date	Block	Lot	Street Number	Street Number Suffix	Street Name	Street Suffix	Unit	Unit Suffix	Description	Current Status	Current Status Date	Filed Date	Issued Date	Completed Date	First Construction Document Date	Structural Notification	Number of Existing Stories	Number of Proposed Stories	Voluntary Soft-Story Retrofit	Fire Only Permit	Permit Expiration Date	Estimated Cost	Revised Cost	Existing Use	Existing Units	Proposed Use	Proposed Units	Plansets	TIDF Compliance	Existing Construction Type	Existing Construction Type Description	Proposed Construction Type	Proposed Construction Type Description	Site Permit	Supervisor District	Neighborhoods - Analysis Boundaries	Zipcode	Location	Record ID
0	M788927	8	otc alterations permit	05/23/2017	0215	001	1333	NaN	jOnEs	St	NaN	NaN	street space	issued	05/23/2017	05/23/2017	05/23/2017	NaN	05/23/2017	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	3.0	Nob Hill	94109.00	(37.79362102799777, -122.41488237355445)	1464153232862
1	201305318356	8	otc alterations permit	05/31/2013	1810	017A	1483	NaN	43rD	Av	NaN	NaN	remodel kitchen: replace countertop, cabinets, sink, stove, hardwood floor & lighting.	complete	08/28/2013	05/31/2013	06/03/2013	08/28/2013	06/03/2013	NaN	2.00	2.00	NaN	NaN	05/29/2014	12000.00	12000.00	1 family dwelling	1.00	1 family dwelling	1.00	2.00	NaN	5.00	wood frame (5)	5.00	wood frame (5)	NaN	4.0	Sunset/Parkside	94122.00	(37.759041020475465, -122.50286985467523)	1306559115258
2	201705106205	8	otc alterations permit	05/10/2017	5700	027	431	NaN	pReNtIsS	St	NaN	NaN	replacement of 4 windows; 2 located in lightwell and 2 at front. replaceing existing vinyl windows with new wood-clad windows. no horizontal mullion in living room window	issued	05/11/2017	05/10/2017	05/11/2017	NaN	05/11/2017	NaN	2.00	2.00	NaN	NaN	05/06/2018	1000.00	2000.00	1 family dwelling	1.00	1 family dwelling	1.00	0.00	NaN	5.00	wood frame (5)	5.00	wood frame (5)	NaN	9.0	Bernal Heights	94110.00	(37.73778863007536, -122.41197863877355)	1462579187173
3	201410279983	8	otc alterations permit	10/27/2014	0661	005	2020	NaN	bUsH	St	NaN	NaN	two kitchens & two bathrooms remodel. replace kitchen cabinets, countertops & appliances in same location. replace tub & faucet & vanity & tile in same location in both units.	complete	12/31/2014	10/27/2014	10/27/2014	12/31/2014	10/27/2014	NaN	2.00	2.00	NaN	NaN	10/22/2015	35000.00	35000.00	2 family dwelling	2.00	2 family dwelling	2.00	0.00	NaN	5.00	wood frame (5)	5.00	wood frame (5)	NaN	5.0	Pacific Heights	94115.00	(37.78762264983362, -122.43099126735969)	136037778128
4	201310280388	8	otc alterations permit	10/28/2013	3642	051A	871	NaN	cApP	St	NaN	NaN	reroofing	issued	10/28/2013	10/28/2013	10/28/2013	NaN	10/28/2013	NaN	2.00	2.00	NaN	NaN	10/23/2014	9900.00	9900.00	apartments	4.00	apartments	4.00	0.00	NaN	5.00	wood frame (5)	5.00	wood frame (5)	NaN	9.0	Mission	94110.00	(37.75275550565926, -122.41707462095194)	1322242163712
5	201307161925	8	otc alterations permit	07/16/2013	3565	076	3479	NaN	16tH	St	NaN	NaN	to comply with physical inspection report #cc-7260 item #1 -all storage items are being removed.	complete	10/08/2013	07/16/2013	07/16/2013	10/08/2013	07/16/2013	NaN	3.00	3.00	NaN	NaN	07/11/2014	7500.00	7500.00	apartments	3.00	apartments	3.00	0.00	NaN	5.00	wood frame (5)	5.00	wood frame (5)	NaN	8.0	Castro/Upper Market	94114.00	(37.76416871595274, -122.43039745629406)	1311167285194
6	M501607	8	otc alterations permit	07/02/2014	3561	007	238	NaN	nOe	St	NaN	NaN	street space	issued	07/02/2014	07/02/2014	07/02/2014	NaN	07/02/2014	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	8.0	Castro/Upper Market	94114.00	(37.76519640087225, -122.4334386869886)	1347642247334
7	M787887	8	otc alterations permit	05/19/2017	0654	009	2338	NaN	pInE	St	NaN	NaN	street space permit	issued	05/19/2017	05/19/2017	05/19/2017	NaN	05/19/2017	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	2.0	Pacific Heights	94115.00	(37.78814050763782, -122.43440743226256)	1463876236318
8	201404113025	8	otc alterations permit	04/11/2014	3740	029	126	NaN	fOlSoM	St	NaN	NaN	existing office and storage facility. new partitions, restroom upgrade. electrical on a separate permit	complete	10/02/2014	04/11/2014	04/25/2014	10/02/2014	04/25/2014	NaN	1.00	1.00	NaN	NaN	04/09/2017	125000.00	125000.00	office	NaN	office	NaN	2.00	NaN	3.00	constr type 3	3.00	constr type 3	NaN	6.0	Financial District/South Beach	94105.00	(37.78992343288329, -122.3915399961996)	1338371165676
9	201702109134	8	otc alterations permit	02/10/2017	0195	001	735	NaN	mOnTgOmErY	St	NaN	NaN	basement & 1/f- as built drawing for fire/smoke damper on hvac duct (existing) under pa#201612074341. n/a ordinance #155-13	complete	03/09/2017	02/10/2017	02/10/2017	03/09/2017	02/10/2017	NaN	4.00	4.00	NaN	NaN	02/05/2018	1.00	1.00	retail sales	0.00	retail sales	0.00	2.00	NaN	3.00	constr type 3	3.00	constr type 3	NaN	3.0	Chinatown	94111.00	(37.79621627942539, -122.40375479881872)	145294162223

	Permit Number	Permit Type	Permit Type Definition	Permit Creation Date	Block	Lot	Street Number	Street Number Suffix	Street Name	Street Suffix	Unit	Unit Suffix	Description	Current Status	Current Status Date	Filed Date	Issued Date	Completed Date	First Construction Document Date	Structural Notification	Number of Existing Stories	Number of Proposed Stories	Voluntary Soft-Story Retrofit	Fire Only Permit	Permit Expiration Date	Estimated Cost	Revised Cost	Existing Use	Existing Units	Proposed Use	Proposed Units	Plansets	TIDF Compliance	Existing Construction Type	Existing Construction Type Description	Proposed Construction Type	Proposed Construction Type Description	Site Permit	Supervisor District	Neighborhoods - Analysis Boundaries	Zipcode	Location	Record ID
198900	201506027767	8	otc alterations permit	06/02/2015	7101A	007	736	NaN	hUrOn	Av	NaN	NaN	reroofing	complete	03/11/2016	06/02/2015	06/02/2015	03/11/2016	06/02/2015	NaN	2.00	2.00	NaN	NaN	05/27/2016	6000.00	6000.00	1 family dwelling	1.00	1 family dwelling	1.00	0.00	NaN	5.00	wood frame (5)	5.00	wood frame (5)	NaN	11.00	Outer Mission	94112.00	(37.71192805393076, -122.4500944316179)	1383549221502
198901	M871027	8	otc alterations permit	12/28/2017	1870	023	1514	NaN	25tH	Av	NaN	NaN	street space	issued	12/28/2017	12/28/2017	12/28/2017	NaN	12/28/2017	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	4.00	Sunset/Parkside	94122.00	(37.75921574765919, -122.48300451049278)	1492023118112
198902	201609208175	8	otc alterations permit	09/20/2016	2130A	006G	78	NaN	cRaGmOnT	Av	NaN	NaN	replace (e) tub with walk in tub, 20 amp circuit, gfci outlet	complete	09/28/2016	09/20/2016	09/20/2016	09/28/2016	09/20/2016	NaN	2.00	2.00	NaN	NaN	09/15/2017	17900.00	17900.00	1 family dwelling	1.00	1 family dwelling	1.00	0.00	NaN	5.00	wood frame (5)	5.00	wood frame (5)	NaN	7.00	Inner Sunset	94116.00	(37.74973733662819, -122.4671301493082)	1438114126978
198903	201407161416	8	otc alterations permit	07/16/2014	2528	024	66	NaN	cReStLaKe	Dr	NaN	NaN	cut a door and a staircase for access to backyard.build deck next to staircase.	complete	01/23/2015	07/16/2014	10/28/2014	01/23/2015	10/28/2014	Y	2.00	2.00	NaN	NaN	10/23/2015	4500.00	6000.00	1 family dwelling	1.00	1 family dwelling	1.00	2.00	NaN	5.00	wood frame (5)	5.00	wood frame (5)	NaN	4.00	Sunset/Parkside	94132.00	(37.73542953855242, -122.48149902038024)	1349089138746
198904	M651047	8	otc alterations permit	12/30/2015	6176	008	342	NaN	hArKnEsS	Av	NaN	NaN	street space	issued	12/30/2015	12/30/2015	12/30/2015	NaN	12/30/2015	NaN	NaN	NaN	NaN	NaN	NaN	NaN	0.00	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	10.00	Visitacion Valley	94134.00	(37.71765127619624, -122.40342209330782)	1407979197645
198905	201604053958	3	additions alterations or repairs	04/05/2016	7295	021	3251	NaN	20tH	Av	NaN	NaN	ti for space 129,130, 132 partitions, mep, shelving, stonestown mall. ab -56 compliance 2014-0627-9771	complete	11/22/2016	04/05/2016	07/18/2016	11/22/2016	07/18/2016	NaN	2.00	2.00	NaN	NaN	07/03/2019	325000.00	928009.20	retail sales	0.00	retail sales	0.00	2.00	NaN	2.00	constr type 2	2.00	constr type 2	NaN	7.00	Lakeshore	94132.00	(37.728556952954136, -122.47676641508518)	1418495226171
198906	201510270880	8	otc alterations permit	10/27/2015	4009	001A	1919	NaN	mArIpOsA	St	NaN	NaN	install new 2" underground combination fire main. ref app#201402108156	issued	10/27/2015	10/27/2015	10/27/2015	NaN	10/27/2015	NaN	3.00	3.00	NaN	Y	10/21/2016	1200.00	9600.00	1 family dwelling	1.00	1 family dwelling	1.00	2.00	NaN	5.00	wood frame (5)	5.00	wood frame (5)	NaN	10.00	Potrero Hill	94107.00	(37.76328445631136, -122.40287014554292)	1400885168656
198907	201607293741	8	otc alterations permit	07/29/2016	4262	020	1341	NaN	sAn bRuNo	Av	NaN	NaN	replace rotten wooden moldings in kind front stairs less than 50% replace	issued	07/29/2016	07/29/2016	07/29/2016	NaN	07/29/2016	NaN	2.00	2.00	NaN	NaN	07/24/2017	1900.00	1900.00	1 family dwelling	1.00	1 family dwelling	1.00	0.00	NaN	5.00	wood frame (5)	5.00	wood frame (5)	NaN	10.00	Mission	94110.00	(37.75260530951628, -122.40400191084352)	1431897172643
198908	201701066691	8	otc alterations permit	01/06/2017	0146	007	660	NaN	bRoAdWaY	NaN	NaN	NaN	revision to pa 2016-0926-8773; remove (e) storefront & doors, remove floor, ceiling & wall finishes for new. new storefront, (n) wall & ceiling finishes, (n) flooring with waterproofing in a (n) alcove. mep under pa#201503100377	issued	02/01/2017	01/06/2017	02/01/2017	NaN	02/01/2017	NaN	2.00	2.00	NaN	NaN	01/27/2018	1.00	1.00	retail sales	9.00	retail sales	9.00	2.00	NaN	5.00	wood frame (5)	5.00	wood frame (5)	NaN	3.00	Chinatown	94133.00	(37.79800446861674, -122.4080339831039)	1449660232064
198909	201604255599	8	otc alterations permit	04/25/2016	3708	056	525	NaN	mArKeT	St	NaN	NaN	16th floor - (4) evacuation plans.	issued	04/25/2016	04/25/2016	04/25/2016	NaN	04/25/2016	NaN	38.00	38.00	NaN	Y	04/20/2017	1600.00	1600.00	office	0.00	office	0.00	2.00	NaN	1.00	constr type 1	1.00	constr type 1	NaN	6.00	Financial District/South Beach	94105.00	(37.79040639954478, -122.39927546096968)	1420790164534

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories